1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Controllers
13 {
14 class CongNoCtrl
15 {
16 //insert cong no
17 public static int InsertCongNo(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId)
18 {
19 try
20 {
21 Models.CongNoMod congNo = new Models.CongNoMod(_IdCongNo, _TieuDe, _LoaiThuChi, _NgayTao, _TrangThai, _SoTien, _Thue, _DienGiai, _LyDo, _NhanVien, _DuocPheDuyet, _GhiChu, _HinhThuc, _NhapHangId);
22 return congNo.InsertCongNo();
23 }
24 catch
25 {
26 return 0;
27 }
28 }
29
30 //update cong no
31 public static int UpdateCongNo(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId)
32 {
33 try
34 {
35 Models.CongNoMod congNo = new Models.CongNoMod(_IdCongNo, _TieuDe, _LoaiThuChi, _NgayTao, _TrangThai, _SoTien, _Thue, _DienGiai, _LyDo, _NhanVien, _DuocPheDuyet, _GhiChu, _HinhThuc, _NhapHangId);
36 return congNo.UpdateCongNo();
37 }
38 catch
39 {
40 return 0;
41 }
42 }
43
44 //update byNhapHangId
45 public static int UpdateCongNo_ByNhapHangId(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId)
46 {
47 try
48 {
49 Models.CongNoMod congNo = new Models.CongNoMod(_IdCongNo, _TieuDe, _LoaiThuChi, _NgayTao, _TrangThai, _SoTien, _Thue, _DienGiai, _LyDo, _NhanVien, _DuocPheDuyet, _GhiChu, _HinhThuc, _NhapHangId);
50 return congNo.UpdateCongNo_ByNhapHangId();
51 }
52 catch
53 {
54 return 0;
55 }
56 }
57
58 // Method Delete
59 public static int DeleteCongNo(int _IdCongNo)
60 {
61 try
62 {
63 Models.CongNoMod congNo = new Models.CongNoMod(_IdCongNo);
64 return congNo.DeleteCongNo();
65 }
66 catch
67 {
68 return 0;
69 }
70 }
71
72
73 //lay danh cong no
74 public static DataSet FillDataSet_CongNo_Search(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId,DateTime _NgayKetThuc, int _pageSize, int _pageIndex)
75 {
76 try
77 {
78 Models.CongNoMod congNo = new Models.CongNoMod(_IdCongNo, _TieuDe, _LoaiThuChi, _NgayTao, _TrangThai, _SoTien, _Thue, _DienGiai, _LyDo, _NhanVien, _DuocPheDuyet, _GhiChu, _HinhThuc, _NhapHangId, _NgayKetThuc, _pageSize, _pageIndex);
79 return congNo.FillDataSet_CongNo_Search();
80 }
81 catch
82 {
83 return null;
84 }
85 }
86
87 //cong no tong hop
88
89 public static DataSet FillDataSet_CongNo_TongHop_Search(DateTime _ThangBaoCao, string _MaDoiTuong, string _TenDoiDUong, int _pageSize, int _pageIndex)
90 {
91 try
92 {
93 Models.CongNoMod congNo = new Models.CongNoMod(_ThangBaoCao, _MaDoiTuong, _TenDoiDUong, _pageSize, _pageIndex);
94 return congNo.FillDataSet_CongNo_TongHop_Search();
95 }
96 catch
97 {
98 return null;
99 }
100 }
101 }
102 }